<?php include('navigation.php'); ?>
<link href="../files/css/semantic.min.css" media="all" rel="stylesheet" type="text/css"/>
<!-- End Navigation -->

<div class="container main-content">
    <!-- DataTables Example -->
    <div class="row">
        <div class="col-lg-12">
            <div class="widget-container fluid-height clearfix">
                <div class="heading">
                    <i class="icon-table"></i>签到列表 <?php if (version_compare(PHP_VERSION, '5.3.0') >0) { ?> <a href="exportqd.php" target="_blank" style="float:right;" data-step="1" data-intro="点击此处导出签到列表EXCEL"><i class="icon-download"></i>导出excel</a><?php } ?>
                  
                </div>
               <!--  <div class="alert alert-warning">
                    <button class="close" data-dismiss="alert" type="button">×</button>
                    声明：抽奖管理采用主动推送消息，只是为了方便活动方与用户的沟通交流，请勿频繁发送或骚扰微信用户，一切后果与作者无关。
                </div> -->
                <div class="widget-content padded clearfix">
                    <table class="table table-striped" id="datatable-editable">
                        <thead>
                        <tr>
                            <th class="hidden-xs">
                                序号
                            </th>
                            <th>
                                昵称
                            </th>
                            <th>
                                姓名（签到填写）
                            </th>
                            <th>
                                手机号（签到填写）
                            </th>
                            
                        </tr>
                        </thead>
                        <tbody>
                        <?php
                        include('biaoqing.php');
                        require_once('../common/db.class.php');
                        $flag_m=new M('flag');
                        // $flag_m->find();
                        //只显示签到的人
                        $querytp=$flag_m->select(' flag>1 order by id desc ');
                        foreach($querytp as $q){
                            $q['nickname'] = pack('H*', $q['nickname']);

                            $q = emoji_unified_to_html(emoji_softbank_to_unified($q));

                           
                            ?>
                            <tr>
                                <td class="hidden-xs">
                                    <?php echo  $q['id']; ?>
                                </td>
                                <td>
                                    <img class="ui avatar image" src="<?php echo  $q['avatar'] ?>"><?php echo  $q['nickname']; ?>
                                </td>
                                <td class="hidden-xs">
                                    <?php echo  $q['signname']; ?>
                                </td>
                                <td class="hidden-xs">
                                    <?php echo  $q['phone']; ?>
                                </td>

                            </tr>
                        <?php
//                        }
                        }
                        ?>

                        </tbody>
                    </table>
                </div>
            </div>
            <!-- end DataTables Example -->
        </div>
    </div>
</div>
<script type="text/javascript">
function showhelp(){
        console.log('show help index');
        introJs().setOptions({
                //对应的按钮
                prevLabel:"上一步", 
                nextLabel:"下一步",
                skipLabel:"跳过",
                doneLabel:"结束"
            }).start();
    }
</script>
</body>
</html>